﻿CREATE TABLE [dbo].[VitalSign] (
    [VitalSignId]   INT          IDENTITY (1, 1) NOT NULL,
    [VisitId]       INT          NOT NULL,
    [VitalSignTypeId] INT          NOT NULL,
    [Value]         VARCHAR (25) NOT NULL,
    PRIMARY KEY CLUSTERED ([VitalSignId] ASC), 
    CONSTRAINT [FK_VitalSign_Visit] FOREIGN KEY ([VisitId]) REFERENCES [Visit]([VisitId]), 
    CONSTRAINT [FK_VitalSign_VitalSignType] FOREIGN KEY ([VitalSignTypeId]) REFERENCES [VitalSignType]([VitalSignTypeId])
);

